package com.ahzy.mapper;


import java.util.List;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import com.ahzy.po.Notice;
import com.ahzy.vo.NoticeAndUser;

@Repository
public interface NoticeMapper extends BaseMapper<Notice> {
	
	@Select("SELECT * FROM notice n LEFT JOIN user u ON n.uid = u.id  WHERE n.title like CONCAT('%',#{title, jdbcType=VARCHAR},'%') ")
    List<NoticeAndUser> selectByUserAndNoticeExamplePage(String title);

}